<!doctype html>
<html>
  <head>
    <meta charset="utf-8">
    <title>CodeMirror: MySQL mode</title>
    <link rel="stylesheet" href="../../lib/codemirror.css">
    <script src="../../lib/codemirror.js"></script>
    <script src="mysql.js"></script>
    <style>.CodeMirror {border-top: 1px solid black; border-bottom: 1px solid black;}</style>
    <link rel="stylesheet" href="../../doc/docs.css">
  </head>
  <body>
    <h1>CodeMirror: MySQL mode</h1>
    <form><textarea id="code" name="code">
-- Comment for the code
-- MySQL Mode for CodeMirror2 by MySQLTools http://github.com/partydroid/MySQL-Tools
SELECT  UNIQUE `var1` as `variable`,
        MAX(`var5`) as `max`,
        MIN(`var5`) as `min`,
        STDEV(`var5`) as `dev`
FROM `table`

LEFT JOIN `table2` ON `var2` = `variable`

ORDER BY `var3` DESC
GROUP BY `groupvar`

LIMIT 0,30;

</textarea></form>
    <script>
      var editor = CodeMirror.fromTextArea(document.getElementById("code"), {
        mode: "text/x-mysql",
        tabMode: "indent",
        matchBrackets: true
      });
    </script>

    <p><strong>MIME types defined:</strong> <code>text/x-mysql</code>.</p>

  </body>
</html>
